SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

create procedure dbo.DnnProduct_VerifyPortal

@PortalID int

as

select dbo.DnnProduct_Tabs.TabId
from dbo.DnnProduct_Tabs
inner join dbo.DnnProduct_Portals on dbo.DnnProduct_Tabs.PortalId = dbo.DnnProduct_Portals.PortalId
where dbo.DnnProduct_Portals.PortalId = @PortalID
and dbo.DnnProduct_Tabs.TabOrder = 1  









GO
